UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uI/c0CL2kjp5I84/0YadkJpJmssfDRo+i+RDiMvHt5U='
WHERE
key_id = 'ed678c168138b57bb640e2de8fd649807fc1e8e1bc4f64685b0ab16b13dc59c3'
AND (
token = 'uI/c0CL2kjp5I84/0YadkJpJmssfDRo+i+RDiMvHt5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)