UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xk6RJzctmY02REDa87x8l22OT6UIFzuWNf+Osp18cI8='
WHERE
key_id = 'f15b2a0ce5a815d61b881be24a0bfa47a42340edcaab32790974a5f08178977f'
AND (
token = 'xk6RJzctmY02REDa87x8l22OT6UIFzuWNf+Osp18cI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)