UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Sxa4w+9eif7kD8paz/NAMRYsshEF5Wf3TaF4H0kLHg='
WHERE
key_id = 'ec7f07aa39965a978259fc91e4d609fd02c943fa602eccea14faddacca2e24da'
AND (
token = '1Sxa4w+9eif7kD8paz/NAMRYsshEF5Wf3TaF4H0kLHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)