UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cPfMvJjVJEoXiCqFeRJ7HEf7B1KEnJSJFk9z6Fczn0U=' 
WHERE 
  key_id = 'd2d9dc387d2619aeb5c7743610a4a87a4611f21c425145a3111015cf5abbcbe5' 
  AND (
    token = 'cPfMvJjVJEoXiCqFeRJ7HEf7B1KEnJSJFk9z6Fczn0U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043