UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z9jjxh64Day2qtDkir+bPS9+ENWkepR0rYCXyE/V78g=' 
WHERE 
  key_id = '60dda8d8d96b94824b2671bad9b9ea1025d742c485ef4ec09b830b0fbe86f4e5' 
  AND (
    token = 'Z9jjxh64Day2qtDkir+bPS9+ENWkepR0rYCXyE/V78g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025