UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'l0kv5mi1/Sy3tII6X1t+TmSonMkc9L84AODq+ruTvLg=' 
WHERE 
  key_id = '4057ce7f6d3221fb797f5c7f33e917a8aafb0e5264706c4d3fbe6383f9923172' 
  AND (
    token = 'l0kv5mi1/Sy3tII6X1t+TmSonMkc9L84AODq+ruTvLg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041