UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rMegZ0KDfvjT03PWuBlKzK61EiS47IEn9wmRf9v1bIY='
WHERE
key_id = 'c74a1a15b57f9de7ef4caf2f6b02c0302b91bc57196b6c5fb5080361047916db'
AND (
token = 'rMegZ0KDfvjT03PWuBlKzK61EiS47IEn9wmRf9v1bIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)