UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tmc+Tp0qxYy4GvnMxQGyS5bwF4z/K1beosChnnCwNAE=' 
WHERE 
  key_id = '9f49842497c94d5ed6daaed6bd8d09a9a397c3f72b3c8d4fd7bfbb16ed845aec' 
  AND (
    token = 'tmc+Tp0qxYy4GvnMxQGyS5bwF4z/K1beosChnnCwNAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022