UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+/SNUAxGW1u6OkUwwiAXuUrz6gYX6tvWJ+/6oCe6tu8=' 
WHERE 
  key_id = 'c71c18f3b5681ee63186aa62c40c5080ff5f86625e4c86d2a9b8f69875ff1bab' 
  AND (
    token = '+/SNUAxGW1u6OkUwwiAXuUrz6gYX6tvWJ+/6oCe6tu8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026