UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sb3bhGEjBC8yfLMPk7XYRosgq2yfWPqU3ixFYszS9cc='
WHERE
key_id = '38e284d855c8eafca230fa03ff1e81530ab4bd419f117f40c1b3edcd6c228e96'
AND (
token = 'Sb3bhGEjBC8yfLMPk7XYRosgq2yfWPqU3ixFYszS9cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)