UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNW1I3k64MOmefP4Nr81lqsPh0khGQLGaLyxrCeV1E8='
WHERE
key_id = '9b7291bd1bc5fe26c36c011039fec7aae5d1d573cbd5a2e7248538807af3bb39'
AND (
token = 'ZNW1I3k64MOmefP4Nr81lqsPh0khGQLGaLyxrCeV1E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)