UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J15V787JnMuOstsaB479puxIYEzAMmawRFyjZztVK00='
WHERE
key_id = 'af461cd3d8868bd360bb30492c7af256e497dd74c84e88877c95d58100fe9652'
AND (
token = 'J15V787JnMuOstsaB479puxIYEzAMmawRFyjZztVK00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)