UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JodYsIyYywGYBtdlVn5q+sSyioqR8PT/kKC5xcYT7M8=' 
WHERE 
  key_id = '9651d5c6686e2ee265b29aab810c8cb89f3d6b832ae28e3ef464f48a94647010' 
  AND (
    token = 'JodYsIyYywGYBtdlVn5q+sSyioqR8PT/kKC5xcYT7M8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026