UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNCJnrmw0W1MMAgLVhSTaKYVAlvHJjeLeeJXEP6hCig='
WHERE
key_id = '93ae6b8307d2c4d16c95de0fa29df20ca381a43f12d324cccd8aeaa42228680e'
AND (
token = 'zNCJnrmw0W1MMAgLVhSTaKYVAlvHJjeLeeJXEP6hCig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)