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