UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zzBD02j+wXuJsLlkFKQCKALcn6ogk9Ctxoi2TVvJ37k=' 
WHERE 
  key_id = '1c5761881ec5fe9797e6864bcf079d4ffd7406b03e3da8fd89d128c2f0b28280' 
  AND (
    token = 'zzBD02j+wXuJsLlkFKQCKALcn6ogk9Ctxoi2TVvJ37k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029