UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmcLhMcUSNwF14YF1M5mapO9jxdHycXq8nPh7lii0Dk='
WHERE
key_id = '19273abf04d0eceedf856c32980518d29b46cdf11f0e46df7c94a7a7c71c178e'
AND (
token = 'pmcLhMcUSNwF14YF1M5mapO9jxdHycXq8nPh7lii0Dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)