UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfgC9dO/6lalzpx9rae6kTNLiGp6C0AZDyUkTaRgwG4='
WHERE
key_id = 'ba22268880d399533e300e8e76c2a75773511c29be570752126f753e382acc23'
AND (
token = 'zfgC9dO/6lalzpx9rae6kTNLiGp6C0AZDyUkTaRgwG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)