UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hH4DnpDT7EQrhxjsgGlq7V6cHiOggl2LwET8nA65XPU='
WHERE
key_id = '9864c3d0372d67ede69b59396f383f266331c6693b7b66cf846ef04cfedbff43'
AND (
token = 'hH4DnpDT7EQrhxjsgGlq7V6cHiOggl2LwET8nA65XPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)