UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOmtzYJ87lf91yS3SfdbgpNnTkEW1wfWLjKvSwJeAI8='
WHERE
key_id = '4ca064ba3dadfccdfce673e2906bc825b73f0fa8dd47628b1918f7aece6af2b6'
AND (
token = 'hOmtzYJ87lf91yS3SfdbgpNnTkEW1wfWLjKvSwJeAI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)