UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yaF0L75/7U9NyIqgi05lSlKsg1fLCFYWoppiKn9RvhE='
WHERE
key_id = 'a9e9a920f8f8658e4fa7dd4e2c358a2becffa14c63117110573963336bf6439a'
AND (
token = 'yaF0L75/7U9NyIqgi05lSlKsg1fLCFYWoppiKn9RvhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)