UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+hSITrcn0pqB2kuiii+J2KOJNWEM9tPf3h8OrSV1Qak=' 
WHERE 
  key_id = '840200730f95b73008243a31ec89d89a967fcb9163e1491c79eb114935451ecf' 
  AND (
    token = '+hSITrcn0pqB2kuiii+J2KOJNWEM9tPf3h8OrSV1Qak=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037