UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nySyxl6ccnxjaEUZ1ir4tW0nwIfG8384es6VTY/g/1o=' 
WHERE 
  key_id = '936ecd7935f79c206f30cc9c7c3ed92b7909f2f00a356b1e8cf05dd85b295db5' 
  AND (
    token = 'nySyxl6ccnxjaEUZ1ir4tW0nwIfG8384es6VTY/g/1o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037