UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pukjnkb3o5cc9TVAP+lnUTLXLsziWjZ0MycPkOE2kpI=' 
WHERE 
  key_id = '5c6343b8ff787b1e7d09a0d5fb0c4de3a6ba335c420898dcc7428077c677b9a1' 
  AND (
    token = 'pukjnkb3o5cc9TVAP+lnUTLXLsziWjZ0MycPkOE2kpI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041