UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bfvB59Ygp2FmhGLhaYTir160lhaXCX62C/6EdcwQZBA='
WHERE
key_id = 'd49908b8c9d78b63a75ad315c49488453fe3e1cec9d1630ac964dda0a5bb9c20'
AND (
token = 'bfvB59Ygp2FmhGLhaYTir160lhaXCX62C/6EdcwQZBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)