UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IjTXtLnQ/Fq47gCgs6WCQGuFUdiV6nqbs3GTooJHuhE=' 
WHERE 
  key_id = '0099c2131ec818f491881856de4a72d98db09920d7c10962a75e9a9b04e08a79' 
  AND (
    token = 'IjTXtLnQ/Fq47gCgs6WCQGuFUdiV6nqbs3GTooJHuhE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034