UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tdvT9VP7/vvK7vPKgusDPrRRin0nuMtkuSjnfiaJdlc=' 
WHERE 
  key_id = '371aefe61f96db13423da52f735784d2c42103570ef929fd99d54b0e4a561b56' 
  AND (
    token = 'tdvT9VP7/vvK7vPKgusDPrRRin0nuMtkuSjnfiaJdlc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021