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