UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZvxeH/ldmoEal0WmHl3dYb/ByShFc2R6D5YNhDB+Pps='
WHERE
key_id = '3c96eae86d5f11ccdad9a3150f916373c4e2ffe816a46d1f6936fa58ded242c6'
AND (
token = 'ZvxeH/ldmoEal0WmHl3dYb/ByShFc2R6D5YNhDB+Pps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)