UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y1GIG1VfM11ccIxgZgUvAnVw81m63j/glwGr9I0JbO0='
WHERE
key_id = '199783c832f0c4cd785728c303636349cf6e39df18da2a7912cebd9bff28e04e'
AND (
token = 'Y1GIG1VfM11ccIxgZgUvAnVw81m63j/glwGr9I0JbO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)