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